Telegram Group & Telegram Channel
Даны следующие таблицы:

Employees
+-----------+---------+------------+
| EmployeeID| Name | Department |
+-----------+---------+------------+
| 1 | John | HR |
| 2 | Jane | IT |
| 3 | Mark | HR |
| 4 | Sarah | IT |
| 5 | Michael | Finance |
+-----------+---------+------------+

Salaries
+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
| 1 | 5000 |
| 2 | 6000 |
| 3 | 5500 |
| 4 | 6500 |
| 5 | 7000 |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A) SELECT Name FROM Employees WHERE Salary > 6000

B) SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

C) SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID



tg-me.com/sql_for_qa/116
Create:
Last Update:

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID| Name | Department |
+-----------+---------+------------+
| 1 | John | HR |
| 2 | Jane | IT |
| 3 | Mark | HR |
| 4 | Sarah | IT |
| 5 | Michael | Finance |
+-----------+---------+------------+

Salaries
+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
| 1 | 5000 |
| 2 | 6000 |
| 3 | 5500 |
| 4 | 6500 |
| 5 | 7000 |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A) SELECT Name FROM Employees WHERE Salary > 6000

B) SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

C) SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

BY SQL для тестировщика


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/116

View MORE
Open in Telegram


SQL для тестировщика Telegram | DID YOU KNOW?

Date: |

Telegram announces Search Filters

With the help of the Search Filters option, users can now filter search results by type. They can do that by using the new tabs: Media, Links, Files and others. Searches can be done based on the particular time period like by typing in the date or even “Yesterday”. If users type in the name of a person, group, channel or bot, an extra filter will be applied to the searches.

Among the actives, Ascendas REIT sank 0.64 percent, while CapitaLand Integrated Commercial Trust plummeted 1.42 percent, City Developments plunged 1.12 percent, Dairy Farm International tumbled 0.86 percent, DBS Group skidded 0.68 percent, Genting Singapore retreated 0.67 percent, Hongkong Land climbed 1.30 percent, Mapletree Commercial Trust lost 0.47 percent, Mapletree Logistics Trust tanked 0.95 percent, Oversea-Chinese Banking Corporation dropped 0.61 percent, SATS rose 0.24 percent, SembCorp Industries shed 0.54 percent, Singapore Airlines surrendered 0.79 percent, Singapore Exchange slid 0.30 percent, Singapore Press Holdings declined 1.03 percent, Singapore Technologies Engineering dipped 0.26 percent, SingTel advanced 0.81 percent, United Overseas Bank fell 0.39 percent, Wilmar International eased 0.24 percent, Yangzijiang Shipbuilding jumped 1.42 percent and Keppel Corp, Thai Beverage, CapitaLand and Comfort DelGro were unchanged.

SQL для тестировщика from ye


Telegram SQL для тестировщика
FROM USA